Tabela CashPayment

Definicja tabeli CashPayment

Name

CashPayment

Code

CashPayment

Comment

 


Lista kolumn tabeli CashPayment

Name

Code

CashPaymentID

CashPaymentID

IdentifierTypeID

IdentifierTypeID

ExternalValue

ExternalValue

CashPaymentTypeID

CashPaymentTypeID

CashPeriodID

CashPeriodID

ContractorID

ContractorID

PaymentTypeID

PaymentTypeID

ExportStatusID

ExportStatusID

Comments

Comments

StartDT

StartDT

InsPersonID

InsPersonID

PaymentTransactionID

PaymentTransactionID


Kolumna CashPaymentID tabeli CashPayment

Definicja kolumny CashPaymentID tabeli CashPayment

Name

CashPaymentID

Code

CashPaymentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna IdentifierTypeID tabeli CashPayment

Definicja kolumny IdentifierTypeID tabeli CashPayment

Name

IdentifierTypeID

Code

IdentifierTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalValue tabeli CashPayment

Definicja kolumny ExternalValue tabeli CashPayment

Name

ExternalValue

Code

ExternalValue

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna CashPaymentTypeID tabeli CashPayment

Definicja kolumny CashPaymentTypeID tabeli CashPayment

Name

CashPaymentTypeID

Code

CashPaymentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CashPeriodID tabeli CashPayment

Definicja kolumny CashPeriodID tabeli CashPayment

Name

CashPeriodID

Code

CashPeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorID tabeli CashPayment

Definicja kolumny ContractorID tabeli CashPayment

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentTypeID tabeli CashPayment

Definicja kolumny PaymentTypeID tabeli CashPayment

Name

PaymentTypeID

Code

PaymentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExportStatusID tabeli CashPayment

Definicja kolumny ExportStatusID tabeli CashPayment

Name

ExportStatusID

Code

ExportStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

Status eksportu dokumentu KP/KW. (Czy dany dokument byl juz wyeksportowany do systemu zewnetrznego FK)


Kolumna Comments tabeli CashPayment

Definicja kolumny Comments tabeli CashPayment

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna StartDT tabeli CashPayment

Definicja kolumny StartDT tabeli CashPayment

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna InsPersonID tabeli CashPayment

Definicja kolumny InsPersonID tabeli CashPayment

Name

InsPersonID

Code

InsPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentTransactionID tabeli CashPayment

Definicja kolumny PaymentTransactionID tabeli CashPayment

Name

PaymentTransactionID

Code

PaymentTransactionID

Data Type

NUMBER(10)

Mandatory

No

Comment

Link do nowej tabelki przechowujacej platnosci online


Lista kluczy tabeli CashPayment

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli CashPayment

Definicja klucza Identifier_1 tabeli CashPayment

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment